UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LFEy8+FvvOhmW7dL3OE3R3pSM2GEP3IMOc+3PumNyZ0='
WHERE
key_id = 'd478a8756fe06cf3cd7b45e6cff0f23e321268781bb1b443e81ab29d81059cb7'
AND (
token = 'LFEy8+FvvOhmW7dL3OE3R3pSM2GEP3IMOc+3PumNyZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)