UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8fxEF+Ji4zgeYGQ5Xhefq78lYXA7L1wyTLcoYT1XZnM='
WHERE
key_id = 'a04add95ec87d1486fa75e1e8392bc61fa7b9183d39ab03823af34a10b357165'
AND (
token = '8fxEF+Ji4zgeYGQ5Xhefq78lYXA7L1wyTLcoYT1XZnM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)