UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bi3kl9pHFOzQ5advMgxWOrtaU/jzqckFCtNJVsMHkIE='
WHERE
key_id = 'aed94149a06c56b12ba4fe7b762b7a8c4d7f1f75d55a26ac589c21b106235e82'
AND (
token = 'bi3kl9pHFOzQ5advMgxWOrtaU/jzqckFCtNJVsMHkIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)