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