UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TPtwrnOn7udNQvNlsaKSrnBr8dDxzsJWm/iTngGucwI='
WHERE
key_id = '9a94b243e1bd907beecba39b481b28982530a375b885697381f7a5f06a93df8a'
AND (
token = 'TPtwrnOn7udNQvNlsaKSrnBr8dDxzsJWm/iTngGucwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)