UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AcfWBB0ep/9/opBneZnmyFkMmQCg7l0GAXF5HtS/HpU='
WHERE
key_id = '3cf30cc906760ca9a974a509a9d36308c6481c5e991b16d6660a204b03b1fe50'
AND (
token = 'AcfWBB0ep/9/opBneZnmyFkMmQCg7l0GAXF5HtS/HpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)