UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g07CVaShLINJ0nBMyiCH1A1CaY8ey4iCKhjFnU0THkg='
WHERE
key_id = 'e81d1af5de4b6b5b7c727b4f39813fc428954094371ef2939efa4ab6e1f09bc8'
AND (
token = 'g07CVaShLINJ0nBMyiCH1A1CaY8ey4iCKhjFnU0THkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)