UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C/cnP2ARturkdYdA9XVYAcmFUS/Iyc17tIF429ayAuo='
WHERE
key_id = 'd4c3f086e48e7154303ad59d2e2afa64f4c641e6136328352d184cfaf081e6ae'
AND (
token = 'C/cnP2ARturkdYdA9XVYAcmFUS/Iyc17tIF429ayAuo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)