UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'USgtJCopAgRwNSnq8nTEASU9Bj9HXBoF5roF71WxzzI='
WHERE
key_id = '3cd5440c388d79351b4067fa5289f1a91d7ca6691cc4fb66662e9cb49542610f'
AND (
token = 'USgtJCopAgRwNSnq8nTEASU9Bj9HXBoF5roF71WxzzI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)