UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iuW3LueG2HuWz2R+yKk88GwEAb/kAoo5llyvHJx7YtA='
WHERE
key_id = '3d3fe0ad44a0685ca145b7c69a1175176a899f5e086f50fd4de882acd511e4c4'
AND (
token = 'iuW3LueG2HuWz2R+yKk88GwEAb/kAoo5llyvHJx7YtA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)