UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/LDi4ACitnBWyi5A4ljLjBYyHLerDN/2xuEw+Izjmlw='
WHERE
key_id = 'adeb27ed3ed7dfee26b16a5c761d04170b4cd335c8d7a8597d12b49db1eab3f9'
AND (
token = '/LDi4ACitnBWyi5A4ljLjBYyHLerDN/2xuEw+Izjmlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)