UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cAi/9kSo871SEu1HC46UoakRuSSE/wptM1kt7pz3EkU='
WHERE
key_id = '9296791f474a2eee60b1b1a841f3aeaaccab78350b7a9719f09a835a73af5cb9'
AND (
token = 'cAi/9kSo871SEu1HC46UoakRuSSE/wptM1kt7pz3EkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)