UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DuuMfCvfFr8hV5aLeHGXVlYkKUlwy5/GOCmr5nm4tx8='
WHERE
key_id = 'dd8748fa1e80461cd65aa18b9ba4612c2a4e095886275f17b4c61f9a00851f23'
AND (
token = 'DuuMfCvfFr8hV5aLeHGXVlYkKUlwy5/GOCmr5nm4tx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)