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