UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lJw7ciIrSNdZfqNQGigaCPl87vuBDBASrZmwSFtbUwc='
WHERE
key_id = '31a04f030e44192549c3746bef15998419308d453c32b5da1fdaa90b9ca9f10d'
AND (
token = 'lJw7ciIrSNdZfqNQGigaCPl87vuBDBASrZmwSFtbUwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)