UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Rs2ZNwJJcJIftHuRiRTZuvboarnitpeQRDOLdf9nqKA='
WHERE
key_id = 'f0fd1665b33c786f276e8fbba4e7bcc1b72db6fe33123521432a915ea3af7aef'
AND (
token = 'Rs2ZNwJJcJIftHuRiRTZuvboarnitpeQRDOLdf9nqKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)