UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DJWDSt7jKRrVcs+3d9nMBq9Hjco6s3qVYWiLDR+3lBw='
WHERE
key_id = '149688cef80fa0a10785fd24d84528ae09f7301939b75246de0730b74586ecb6'
AND (
token = 'DJWDSt7jKRrVcs+3d9nMBq9Hjco6s3qVYWiLDR+3lBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)