UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VvH1SPgPzxAoi2nA4re0Rn3t2rJjcEVZvV3+wqIQLX0='
WHERE
key_id = 'b04618322cd9b608494608cba20a56279c717439bb0157163d57c385c64c6ed5'
AND (
token = 'VvH1SPgPzxAoi2nA4re0Rn3t2rJjcEVZvV3+wqIQLX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)