UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a0+oyzRZwDPRCMfaWK16NQOjsI61HAaiPeV8r1KYwcM='
WHERE
key_id = '2a97fecd8bad03b9784b4123d5c68612ca4ade29866e942958c5956f0aed576b'
AND (
token = 'a0+oyzRZwDPRCMfaWK16NQOjsI61HAaiPeV8r1KYwcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)