UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '12vp9V+NU+YmKYwJD2cos3P0ZesWZiVd4asMtCNakA4='
WHERE
key_id = 'c4d9642e045587b7ca003516ff0ba48b675b4ddea2b99bb6365859e7e61e063e'
AND (
token = '12vp9V+NU+YmKYwJD2cos3P0ZesWZiVd4asMtCNakA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)