UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N6o2KYchYa1VOxyH1p4OJnK6laNJGRB0XHaj+CCATq0='
WHERE
key_id = 'cecd5cda65e96634e030742c96fca3c78c495a20eb43ae0befd4e2c0cf8c4046'
AND (
token = 'N6o2KYchYa1VOxyH1p4OJnK6laNJGRB0XHaj+CCATq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)