UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9rPBF0BBqduDq5ZeMge3RDPjo8Djmhr4Yt9AB/eKMSM='
WHERE
key_id = '0c0a4de987a45233e70f703ffcc5b202e1f3dc7366b438199b53ed3689ae51dc'
AND (
token = '9rPBF0BBqduDq5ZeMge3RDPjo8Djmhr4Yt9AB/eKMSM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)