UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OTSu7lOYMKQtXH+rDOOkohPdsfCXhlx0vp/15Pgx49Y='
WHERE
key_id = '8c76aed4e147f964c643b1689c115df4779a03b1bebb60b8c304f076a8752923'
AND (
token = 'OTSu7lOYMKQtXH+rDOOkohPdsfCXhlx0vp/15Pgx49Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)