UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KB/4Ub7n+xA1zk9etYKCUoDrD1W6bN8szrcPLDTaviY='
WHERE
key_id = '471ae856cdb08e844f8ea56b0242fa4f6ed3de96000e3b2999214c1250e8cbef'
AND (
token = 'KB/4Ub7n+xA1zk9etYKCUoDrD1W6bN8szrcPLDTaviY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)