UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tSCDqPeKNoSD55PTZwoB6io5vsgt31tbdhGhp5uDR+U='
WHERE
key_id = '5850975d42452b23cf27f98e4d249036088c6afb991291270271092f6abd0d20'
AND (
token = 'tSCDqPeKNoSD55PTZwoB6io5vsgt31tbdhGhp5uDR+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)