UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WZ7Df7R2hr5ddSdLBxjukSlQmKMxuObeeyCK41YKqgo='
WHERE
key_id = 'e08cbc58a35bef28b6003567eaff554f4a38df76c338a7d61ccec636b4d7f946'
AND (
token = 'WZ7Df7R2hr5ddSdLBxjukSlQmKMxuObeeyCK41YKqgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)