UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xs9s6duYvKz85ePYBy5znKeIKceX+obLbgIRTVjeNYs='
WHERE
key_id = '147bb2ecde00861199881a5a58d7026763161f0d3c05d83062a85748dce1bce8'
AND (
token = 'xs9s6duYvKz85ePYBy5znKeIKceX+obLbgIRTVjeNYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)