UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mfRLvTdXtgl6w5h7I7zxV9IbtXBYc0Bm+ZlYEH5L114='
WHERE
key_id = 'd53773aff4b88b2e885c44f55e0715b016498418b985b12c42b91f19762cd004'
AND (
token = 'mfRLvTdXtgl6w5h7I7zxV9IbtXBYc0Bm+ZlYEH5L114='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)