UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BXm2SgAIW9RNX2wPU4ukFZU1V18lNzs9eapb5NwKW4s='
WHERE
key_id = '2c5af7c1eadff09cdec06a1bb58e08dea962393523d6a61ac36bf69c2b236858'
AND (
token = 'BXm2SgAIW9RNX2wPU4ukFZU1V18lNzs9eapb5NwKW4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)