UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cXqXURb2OxMsieVTJzh1M6En6BK771eIEaujrdwxAPw='
WHERE
key_id = '3c2f9443921002559925c21822dd46f6567135dfb9efc95797438e33152de1fb'
AND (
token = 'cXqXURb2OxMsieVTJzh1M6En6BK771eIEaujrdwxAPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)