UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N66W6N2qKfwq1+a0rcao8NSOkmZttKpv3L73+OIDIuE='
WHERE
key_id = 'dee333a55e6e5b18519ae40b6553a78e693bf3113e1bb4695657f2090166bacb'
AND (
token = 'N66W6N2qKfwq1+a0rcao8NSOkmZttKpv3L73+OIDIuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)