UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qo8HzkEUidyq5MaecvLLIE2Q7Sf5LL5m9dMny7EciME='
WHERE
key_id = 'e77b41c688f9c4bd99c4df3b59fb4fb4b66818bdb3143361212b40b1f1ef8e74'
AND (
token = 'qo8HzkEUidyq5MaecvLLIE2Q7Sf5LL5m9dMny7EciME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)