UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U6LcJXrEF8vRqsIxS7W97AVEvebUsW3FWZn6pjRauRc='
WHERE
key_id = '5d0974a4020f250a52085e05ad3b525cb830dd72a3dd2c40a75f53feeec74cd3'
AND (
token = 'U6LcJXrEF8vRqsIxS7W97AVEvebUsW3FWZn6pjRauRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)